dataSource {
	pooled = true
	driverClassName = "oracle.jdbc.OracleDriver"
	dialect = "org.hibernate.dialect.Oracle10gDialect"

	//datasource examples,you web lib folder must have your-database-driver.jar

	/*
	 mysql example
	 url = "jdbc:mysql://localhost/yourDB"
	 driverClassName = "com.mysql.jdbc.Driver"
	 dialect = org.hibernate.dialect.MySQL5InnoDBDialect
	 */
	/*
	 h2 example
	 url = "jdbc:h2:file:example"
	 url = "jdbc:h2:mem:devDb"
	 driverClassName = "org.h2.Driver"
	 dialect = "org.hibernate.dialect.H2Dialect"
	 */
	/*
	 hsqldb example
	 url = "jdbc:hsqldb:file:prodDb;shutdown=true"
	 url = "jdbc:hsqldb:mem:devDB"
	 driverClassName = "org.hsqldb.jdbcDriver"
	 dialect = "org.hibernate.dialect.HSQLDialect"
	 */

	/*
	 jndi example
	 jndiName = "java:comp/env/myDataSource"
	 */
}
hibernate {
	cache.use_second_level_cache = true
	cache.use_query_cache = true
	cache.provider_class = 'net.sf.ehcache.hibernate.EhCacheProvider'
	naming_strategy = 'ns.gflex.orm.PrefixedNamingStrategy'
}
// environment specific settings
environments {
	development {
		dataSource {
			// one of 'create', 'create-drop','update'
			dbCreate = "create-drop"
			url = "jdbc:oracle:thin:@130.1.108.209:1521:sjck"
			//url = "jdbc:oracle:thin:@localhost:1521:xe"
			logSql = true
			username = "grails"
			password = "grails"
		}
	}
	test {
		dataSource {
			url = "jdbc:oracle:thin:@localhost:1521:xe"
			logSql = true
			username = "grails"
			password = "grails"
		}
	}
	production {
		dataSource {
			url = "jdbc:oracle:thin:@ip:1521:sid"
			dbCreate = "create"
			username = ""
			password = ""
		}
	}
}
